﻿CREATE TABLE [trUser].[tblDrivers] (
    [IDDriver]             BIGINT         IDENTITY (1, 1) NOT NULL,
    [IDUser]               BIGINT         NOT NULL,
    [QRCodeImage]          BINARY (50)    NULL,
    [ImageURL]             NVARCHAR (255) NULL,
    [DriverImage]          BINARY (50)    NULL,
    [DriverImageDateTaken] DATETIME       NULL,
    [DateCreated]          DATETIME       CONSTRAINT [DF_tblDrivers_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]          DATETIME       NULL,
    [DateInactive]         DATETIME       NULL,
    CONSTRAINT [PK_tblDrivers] PRIMARY KEY CLUSTERED ([IDDriver] ASC)
);

